Excel CoursesHalf Price Complete Excel CourseTrading Software $\r\nNeural Network Software $\r\nExcel Trading Addins $\r\n\r\nLEARN TRADING USING EXCEL\r\nBuild an Automated Stock Trading System $\r\nBuild an Automated Sector Fund System $\r\nBuild an Spread Trading System $\r\n\r\nCURRENT BEST BUY!\r\nExcel Trader Package Technical AnalyzerXL Package (also sold separately) Bulk Quotes Excel Downloader Excel (also sold separately) RealTime Quotes Excel Predictor Excel (also sold separately) Back-testing Excel Classifier Excel (also sold separately) Portfolio Excel Options Excel (also sold separately).\r\n\r\n30 Day Money Back Guarantee and over 0.00 of FREE software!", "style=\"background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;\"");' style="FONT-STYLE: italic" onmouseout=GAL_hidepopup(); href="http://www.ozgrid.com/forum/autolink.php?id=11&script=showthread&forumid=34">TRADING;Build an Automated Stock Trading SystemBuild an Automated Sector Fund SystemBuild an Automated Spread Trading SystemTechnical Indicators Library Open Source All TrainingAdd-insCode Module and paste in the code.\r\n\r\nPrivate Macro Module Code\r\nIf code begins with the words Private Sub the code MUST be placed in the correct Private Module. This will normally be one of three places.\r\n\r\n1) Private Module of the SheetObject (Sheet1, Sheet2...)\r\nIf the code starts with: Private Sub WorksheetSomething you can quickly access the Private Module of the SheetObject. While in Excel, right click on the WorksheetName tab and select \"View Code\".\r\n\r\n2) Private Module of the WorkbookObject (ThisWorkbook)\r\nIf the code starts with: Private Sub WorkBookSomething you can quickly access the Private Module of the Workbook Object. while in Excel, right click on the Excel icon (top left next to \"File\") and select \"View Code\".\r\n\r\n3) Private Module of the UserFormObject (UserForm1 etc\r\nIf the code is intended for a UserForm, or a Control on a UserForm, it must be placed in the Private Module of the UserForm Object. This is easily done by double clicking the UserForm while inside the Visual Basic Editor (VBE).\r\n\r\nTIP: The ObjectReference back to any of the above 3 can always be the keyword Me.\r\n\r\nBETTER CODE BUILDERS/HELP\r\nVBA-VB Code Builders\r\nSmart VBA\r\nCODE PRINTING\r\nCode Printing Software. Lots. $", "style=\"background: #FFFFFF;padding: 2px;font-size: 10px;width: 850px;\"");' style="FONT-STYLE: italic" onmouseout=GAL_hidepopup(); href="http://www.ozgrid.com/forum/autolink.php?id=1&script=showthread&forumid=34">VB & VBA With Code VBA coding tools added to your Visual Basic editor (VBE) you create better VBA Excel macros faster. A set of 17 specialized code builders supports the Speeding Up Slow Macros\r\nSpeed up VBA By Turning Off/On Calculations\r\n\r\n\r\nMS Excel: Improving Performance", "style=\"background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;\"");' style="FONT-STYLE: italic" onmouseout=GAL_hidepopup(); href="http://www.ozgrid.com/forum/autolink.php?id=34&script=showthread&forumid=34">fast creation of most used code. Use with MS Access, Excel, Word and other VBA applications.Smart VBA Useful development tool for VBA programmers that was created to build fast and robust VBA code. The program includes a number of intuitively understandable modules that help in programming: Powerful Project Explorer, Procedures and Microsoft Excel Formulas, Tip, Tricks and Feature Examples\r\nStop Formula Viewing\r\nExamples of Commonly Used Formulas\r\nList & Examples of All Formulas\r\nExcel Formula Manager $\r\n\r\nNESTED IF LIMITATION\r\nNested IF Limitation Work-around. Preferred Method\r\nNested IF Limitation Work-around 2\r\n\r\nCUSTOM FORMULAS/FUNCTIONS UDFs\r\nCustom Functions", "style=\"background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;\"");' style="FONT-STYLE: italic" onmouseout=GAL_hidepopup(); href="http://www.ozgrid.com/forum/autolink.php?id=17&script=showthread&forumid=34">Functions Builder, Workbook Open Event\r\n WorkSheetChange Event", "style=\"background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;\"");' style="FONT-STYLE: italic" onmouseout=GAL_hidepopup(); href="http://www.ozgrid.com/forum/autolink.php?id=39&script=showthread&forumid=34">Properties Builder, Collections Builder, Enum Builder, Enhanced Handling Run-time Errors\r\nSub Stop_All_Errors()\r\nOn Error Resume Next\r\nYOUR CODE\r\nOn Error GoTo 0 'Resets error trapping\r\nEnd Sub\r\n\r\nSub Custom_Error_Message()\r\nOn Error GoTo MyCstmErr\r\nYOUR CODE\r\nExit Sub\r\nMyCstmErr: Msgbox \"My Custom Error Message\"\r\nEnd Sub\r\n\r\nSub Stop_Warning_Alerts()\r\nApplication.DisplayAlerts=False\r\n 'Your code here! Example might be ActiveSheet.Delete\r\nApplication.DisplayAlerts=True\r\nEnd Sub\r\nAlso see Excel VBA Runtime Errors & Preventing Them\r\n\r\nFORMULA ERRORS\r\n\r\nExcel Formula Errors & How To Deal With Them\r\n\r\nISERR Function: For any error type except #N/A. \r\nISERROR Function: For any error type.\r\nISNA Function: For the #N/A error type.\r\nError.Type Function: For specifying error types. #NULL! = 1 #DIV/0! 2 #VALUE! 3 #REF! 4 #NAME? 5 #NUM! 6 #N/A 7 \r\n\r\nE.g =IF(ISERROR(VLOOKUP(Arguments)),0,VLOOKUP(Arguments))\r\nSee Efficient Spreadsheet Designs for better ways.", "style=\"background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;\"");" style="FONT-STYLE: italic" onmouseout=GAL_hidepopup(); href="http://www.ozgrid.com/forum/autolink.php?id=31&script=showthread&forumid=34">Error Handler Manager, Snippets: code libraryPrint VBA This add-in enables you to print Microsoft VBA source code in color of your applications across the entire Microsoft Office 2000 suite of applications: Word, Excel, Outlook Add-ins\r\n\r\nEMAIL\r\nSend Emails From Excel", "style=\"background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;\"");' style="FONT-STYLE: italic" onmouseout=GAL_hidepopup(); href="http://www.ozgrid.com/forum/autolink.php?id=23&script=showthread&forumid=34">Outlook, Access, PowerPoint, and FrontPage and any other VBA enabled software. Learn just what your Excel Macros do.COM XL RS232C Add-In for Excel $\r\nAutoCAD Add-in to Draw Tables in AutoCAD\r\nMechanical & Technical Calculation Software", "style=\"background: #FFFFFF;padding: 2px;font-size: 11px;\"");' style="FONT-STYLE: italic" onmouseout=GAL_hidepopup(); href="http://www.ozgrid.com/forum/autolink.php?id=21&script=showthread&forumid=34">RS232C COMxLCOMxL, an ease-to-use and helpful Add-Ons/Add-Ins of MS Excel 97/2000, lets you your measuring instrument (like Micrometer, Calliper, Temperature, Balance and Bar-Code scanner...) to your any Excel How to Reference Sheets In VBA. By Index number, Tab name and CodeName.\r\nTest if Sheet Exists\r\nCreate Sheets Based on a List\r\nSort Sheets\r\nGroup Sheets by Tab Color\r\nGovern Worksheet Scrolling\r\nPrevent Worksheet Viewing\r\nDelete Sheet Code via VBA\r\nCreate Sheet Index\r\nAdd Sheets\r\nAdd Sheets In Weekday Order\r\nAdd Sheets In Month Order\r\nAdd Sheets In Numeric Order\r\nWorksheet Names in XlFormulas\r\n\r\nPROTECTION\r\nRun Macros On Protected Worksheets & Sheets", "style=\"background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;\"");' style="FONT-STYLE: italic" onmouseout=GAL_hidepopup(); href="http://www.ozgrid.com/forum/autolink.php?id=18&script=showthread&forumid=34">worksheet directly via RS232 or COM port.COM Excel is a powerful ActiveX Control with over a hundred useful functions to assist in exchanging data between Excel and Visual Basic and much more using COM technology! Included in the download is a sample Visual Basic project which demonstrates the power of Excel Macros & OCX. Download it now and see for yourself how your programming time can be Disable Cut/Copy in Excel Workbooks", "style=\"background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;\"");" style="FONT-STYLE: italic" onmouseout=GAL_hidepopup(); href="http://www.ozgrid.com/forum/autolink.php?id=35&script=showthread&forumid=34">cut down drastically with this handy control!All Excel Add-insAccess Add-insAll Software With VBA Find Method. Method Well Worth Learning!Find Number Between 2 NumbersFind With x CriteriaAdvanced Excel Find $Advanced Excel Find & Replace $Advanced Excel Find & Replace Closed Workbooks $ SEARCHSearch ForumsSearch Ozgrid SiteSearch Software & ProductsSearch Lots of Excel SitesSEARCH OZGRID FORUM Check out the new Excel Video Tutorials", "style=\"background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;\"");' style="FONT-STYLE: italic" onmouseout=GAL_hidepopup(); href="http://www.ozgrid.com/forum/autolink.php?id=50&script=showthread&forumid=34">Search
Creating A New Document
Click on File
Select New
To create a blank document, simply select Blank Document. To create a document based on one of the templates provided in Microsoft Word, select which one you would like to create and select OK
Formatting Text
Highlight the text that you want to format by dragging your mouse over while holding down the left mouse button
Change the text to your desire
Go To Page.. Main Page Logging In/Out Your Computer Windows 98 Microsoft Office 2000 GroupWise 5 Email Internet Student Attendance Student Grade Reporting Student Records (CIMS)
Microsoft PowerPoint
Microsoft Access
Microsoft Office Main
Microsoft Excel
Microsoft Publisher
Introduction into Microsoft WordStarting Up Microsoft WordLearn the ToolbarCreating A New DocumentFormatting TextInserting A TableInserting A PictureInserting Page Numbers and Date/TimeSpelling and Grammar CheckingIntroduction into Microsoft Word Microsoft Word is a powerful tool to create professional looking documents. This tutorial will help you get started with Microsoft Word and may solve some of your problems, but it is a very good idea to use the Help Files that come with Microsoft Word , or go to Microsoft's web site located at http://microsoft.com/office/word/default.htm for further assistance. Back to top Starting Microsoft Word
Two Ways
Double click on the Microsoft Word icon on the desktop.
Click on Start --> Programs --> Microsoft Word Back to top Viewing the toolbars The toolbars in Microsoft Word provide easy access and functionality to the user. There are many shortcuts that can be taken by using the toolbar. First, make sure that the proper toolbars are visible on the screen.
Click View
Select Toolbars
Select Standard, Formatting, and Drawing
Other toolbars can be selected if you wish
Name
Icon
Description
New Blank Document
Creates a new, blank file based on the default template.
Open (File menu)
Opens or finds a file.
Save (File menu)
Saves the active file with its current file name, location, and file format.
Mail Recipient
Sends the contents of the document as the body of the e-mail message.
Print (File menu)
Prints the active file or selected items. To select print options, on the File menu, click Print.
Print Preview (File menu)
Shows how a file will look when you print it.
Spelling and Grammar (Tools menu)
Checks the active document for possible spelling, grammar, and writing style errors, and displays suggestions for correcting them. To set spelling and grammar checking options, click Options on the Tools menu, and then click the Spelling and Grammar tab.
Cut (Edit menu)
Removes the selection from the active document and places it on the Clipboard.
Copy (Edit menu)
Copies the selection to the Clipboard.
Paste (Edit menu)
Inserts the contents of the Clipboard at the insertion point, and replaces any selection. This command is available only if you have cut or copied an object, text, or contents of a cell.
Format Painter (Standard toolbar)
Copies the format from a selected object or text and applies it to the object or text you click. To copy the formatting to more than one item, double-click , and then click each item you want to format. When you are finished, press ESC or click again to turn off the Format Painter.
Undo (Edit menu)
Reverses the last command or deletes the last entry you typed.
Redo (Edit menu)
Reverses the action of the Undo command.
Hyperlink
Inserts a new hyperlink or edits the selected hyperlink.
Tables and Borders
Displays the Tables and Borders toolbar, which contains tools for creating, editing, and sorting a table and for adding or changing borders to selected text, paragraphs, cells, or objects.
Zoom
Enter a magnification between 10 and 400 percent to reduce or enlarge the display of the active document.
Office Assistant
The Office Assistant provides Help topics and tips to help you accomplish your tasks.Back to top Creating A New Document
Click on File
Select New
To create a blank document, simply select Blank Document. To create a document based on one of the templates provided in Microsoft Word, select which one you would like to create and select OK Back to top Formatting Text
Highlight the text that you want to format by dragging your mouse over while holding down the left mouse button
Change the text to your desire
Back to top Inserting a Table
Click where you want your table to go
Click Table at top of screen
Select Insert
Select Table
Give your table dimensions Back to top Inserting a Picture
Click where you want your picture to go
Click Insert at top of screen
Select Picture
Select Clip Art or From File
Select picture and click Insert Back to top Inserting Page Numbers and Date/Time
Click Insert at top of screen
Select Page Numbers and/or Date & Time Back to top Spell Checking Your Document
Click Tools at top of screen
Select Spelling and Grammar
EXCEL BASICS
Below is a picture of what Microsoft Excels main screen may look like. As you can notice the working environment is a several boxes or what are referred to as cells. Across the top you will notice alphabetic letters which represent columns. Columns are rows that lay vertically. Along the left hand side of the screen you notice numbers these are to represent the rows which go horizontally or left to right.
FORMATTING CELLS
Before creating the spread sheet the user must decide how the spread sheet is going to work and what its function is. We are going to create a layout of a basic checking account spread sheet to show you some key features of Excel. As you can notice with the bottom example we have created a blue bar to distinguish the categories of the checking account. To change the colors of cells you first must highlight the cells you wish to change colors. Hint if you want to highlight the whole row or column click on the letter or number of the row or column that you want to highlight. Once the selected cells have been highlighted on the main tool bar click on Format / Cells / Patterns, under pattern select the color that you would like the cells to be if you do not want the cells to be a completely blue you can also select the pattern in this window as well.
FORMULAS
Spread sheets are most popular for their capability of being able to calculate other cells with formulas without you having to do all the hard work and be automatically updated if any cell is changed. In the below image we have given and example of a simple formula that can be extended or used in your own spread sheets. As you can notice in the below illustration in the top right hand corner of the box =SUM(A2:B2), SUM is inputted. This is an example of an Excel formula. In Parentheses you notice A2:B2 these are references to the cells A2 which = 10 and B2 which = 20 when added together which is represented in this case by a colon they equal 30 which will then be displayed automatically in C2 which is where the formula is. So if the A2 was to change to 20 C3 would automatically be updated to 40 because 20 + 20 = 40. For more information on formulas please see are formula section on this page.
NUMBERING
When creating information on the spread sheets changing the number format may be required to create a dollar format such as $5.45 instead of 5.45 to help readers understand the format. Select the cells you wish to change the format of and click Format / and within the Number tab as shown below notice the category box which allows you to choose the type of scheme for the numbers. Currently selected is Currency, once selected additional options can be set such as as setting the decimal placing value in this case we set the standard decimal of 2, we have also set the symbol to $ to other types of currencies around the world.
Note: If you did not highlight a cell with a number format you will not get an example as shown below.
CHARTS
In the below example there are many aspects to point out, first before attempting to create a chart you will find it much easier to highlight the values that you wish to chart in the example below you notice we have a small spread sheet to the left of the picture which is represented by #1 which as you can see are all highlighted. Once highlighted click on the chart wizard icon which is represented by #2 at the top of the picture. Once you have clicked on the chart wizard button it will bring up a simple wizard that will help you go through the process. To the left of the window represented by #3 you notice a chart type window which allows you to select the type of chart you wish to use such as bar, pie, stock, etc. Once the type of bar graph has been select you will want to choose the sub type of Chart you wish to create represented by #4. A special note once you believe you have found the chart you want before clicking on next click and hold on the button represented by #5 that says "Press and hold to view sample" This will show you what your graph is going to look like before clicking next. Once you have finished with this screen click Next and continue on through out the wizard for additional features. Or click finish to complete the chart.
FREEZE
Freeze is an extremely nice feature that allows you to easily work with very large spread sheets without loosing the capability of seeing what each row represents. To create a freeze first highlight the row under the row(s) that you want to freeze. For example if you wanted to freeze row number one you would highlight row number two by clicking on number two. Once the row has been highlighted click on the drop down menu at the top of the screen that says window then click on freeze. Now if you were to put a bunch of information on column and scroll down you will notice that all rows scroll but number one. An example of how you can use this is to put your checking account information across as shown in the below example.then freeze row number one then you can have several pages of information that you can scroll down and never loose track of what each column represents.
